Hello everyone,
Standard EXCEL is configured to show numbers as follows: 132.546,256
(hundred and thirty two thousand five hundred and fourty six AND two hundred and fifty six thousands)
Just in one file I need formatting to be as follows: 132546.256.
So decimal values noted with periods . and not kommas ,.
Through adapted cell properties I dont get there.
To change the standard configuration of EXCEL is no option as it would change the formatting of ALL my files, which I dont want.
It is about an application whereby cordinates in QGIS (Software for a
Geografical Information Syseem) are copied and pasted into EXCEL.
QGIS Works with the American formatting ("." instead of ","). Then I need to re-upload the file again to a site working with the American system.
A workaround could be to create a new user on the PC and to use in this configuration EXCEL without the 1000-separator and a period (.) as a decimal separator.
But thats not really a work friendly solution as most of my work is done in the European system, i.e. "," for decimal numbers.
Thank you for a clear and superb solution!
- Moved by Lanlan HuangMicrosoft contingent staff 4 hours 58 minutes ago